<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>FencesContentProvider xref</title>
<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../../apidocs/org/inftel/tms/mobile/contentproviders/FencesContentProvider.html">View Javadoc</a></div><pre>

<a class="jxr_linenumber" name="1" href="#1">1</a>   <strong class="jxr_keyword">package</strong> org.inftel.tms.mobile.contentproviders;
<a class="jxr_linenumber" name="2" href="#2">2</a>   
<a class="jxr_linenumber" name="3" href="#3">3</a>   <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> android.text.TextUtils.isEmpty;
<a class="jxr_linenumber" name="4" href="#4">4</a>   <strong class="jxr_keyword">import</strong> android.content.ContentProvider;
<a class="jxr_linenumber" name="5" href="#5">5</a>   <strong class="jxr_keyword">import</strong> android.content.ContentUris;
<a class="jxr_linenumber" name="6" href="#6">6</a>   <strong class="jxr_keyword">import</strong> android.content.ContentValues;
<a class="jxr_linenumber" name="7" href="#7">7</a>   <strong class="jxr_keyword">import</strong> android.content.Context;
<a class="jxr_linenumber" name="8" href="#8">8</a>   <strong class="jxr_keyword">import</strong> android.content.UriMatcher;
<a class="jxr_linenumber" name="9" href="#9">9</a>   <strong class="jxr_keyword">import</strong> android.database.Cursor;
<a class="jxr_linenumber" name="10" href="#10">10</a>  <strong class="jxr_keyword">import</strong> android.database.SQLException;
<a class="jxr_linenumber" name="11" href="#11">11</a>  <strong class="jxr_keyword">import</strong> android.database.sqlite.SQLiteDatabase;
<a class="jxr_linenumber" name="12" href="#12">12</a>  <strong class="jxr_keyword">import</strong> android.database.sqlite.SQLiteDatabase.CursorFactory;
<a class="jxr_linenumber" name="13" href="#13">13</a>  <strong class="jxr_keyword">import</strong> android.database.sqlite.SQLiteException;
<a class="jxr_linenumber" name="14" href="#14">14</a>  <strong class="jxr_keyword">import</strong> android.database.sqlite.SQLiteOpenHelper;
<a class="jxr_linenumber" name="15" href="#15">15</a>  <strong class="jxr_keyword">import</strong> android.database.sqlite.SQLiteQueryBuilder;
<a class="jxr_linenumber" name="16" href="#16">16</a>  <strong class="jxr_keyword">import</strong> android.net.Uri;
<a class="jxr_linenumber" name="17" href="#17">17</a>  <strong class="jxr_keyword">import</strong> android.text.TextUtils;
<a class="jxr_linenumber" name="18" href="#18">18</a>  <strong class="jxr_keyword">import</strong> android.util.Log;
<a class="jxr_linenumber" name="19" href="#19">19</a>  
<a class="jxr_linenumber" name="20" href="#20">20</a>  <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="21" href="#21">21</a>  <em class="jxr_javadoccomment"> * Content Provider and database for storing the list of fences Proveedor de contenido y base de</em>
<a class="jxr_linenumber" name="22" href="#22">22</a>  <em class="jxr_javadoccomment"> * datos para almecenar las vallas del dispositivo.</em>
<a class="jxr_linenumber" name="23" href="#23">23</a>  <em class="jxr_javadoccomment"> * </em>
<a class="jxr_linenumber" name="24" href="#24">24</a>  <em class="jxr_javadoccomment"> * TODO mas separacion entre Provider y datos de tabla (mirar siguiente enlace)</em>
<a class="jxr_linenumber" name="25" href="#25">25</a>  <em class="jxr_javadoccomment"> * <a href="http://www.vogella.de/articles/AndroidSQLite/article.html" target="alexandria_uri">http://www.vogella.de/articles/AndroidSQLite/article.html</a>#tutorialusecp_overview</em>
<a class="jxr_linenumber" name="26" href="#26">26</a>  <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="27" href="#27">27</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../org/inftel/tms/mobile/contentproviders/FencesContentProvider.html">FencesContentProvider</a> <strong class="jxr_keyword">extends</strong> ContentProvider {
<a class="jxr_linenumber" name="28" href="#28">28</a>  
<a class="jxr_linenumber" name="29" href="#29">29</a>  	<em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The underlying database */</em>
<a class="jxr_linenumber" name="30" href="#30">30</a>  	<strong class="jxr_keyword">private</strong> SQLiteDatabase fencesDB;
<a class="jxr_linenumber" name="31" href="#31">31</a>  
<a class="jxr_linenumber" name="32" href="#32">32</a>  	<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String TAG = <span class="jxr_string">"FencesContentProvider"</span>;
<a class="jxr_linenumber" name="33" href="#33">33</a>  	<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String DATABASE_NAME = <span class="jxr_string">"fences.db"</span>;
<a class="jxr_linenumber" name="34" href="#34">34</a>  	<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> DATABASE_VERSION = 1;
<a class="jxr_linenumber" name="35" href="#35">35</a>  	<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String FENCES_TABLE = <span class="jxr_string">"fences"</span>;
<a class="jxr_linenumber" name="36" href="#36">36</a>  
<a class="jxr_linenumber" name="37" href="#37">37</a>  	<em class="jxr_comment">// Column Names</em>
<a class="jxr_linenumber" name="38" href="#38">38</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_ID = <span class="jxr_string">"_id"</span>;
<a class="jxr_linenumber" name="39" href="#39">39</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_NAME = <span class="jxr_string">"name"</span>;
<a class="jxr_linenumber" name="40" href="#40">40</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_LOCATION_LAT = <span class="jxr_string">"latitude"</span>;
<a class="jxr_linenumber" name="41" href="#41">41</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_LOCATION_LNG = <span class="jxr_string">"longitude"</span>;
<a class="jxr_linenumber" name="42" href="#42">42</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_ZONE_TYPE = <span class="jxr_string">"inclusionzone"</span>;
<a class="jxr_linenumber" name="43" href="#43">43</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_RADIUS = <span class="jxr_string">"radius"</span>;
<a class="jxr_linenumber" name="44" href="#44">44</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_LAST_UPDATE_TIME = <span class="jxr_string">"lastupdatetime"</span>;
<a class="jxr_linenumber" name="45" href="#45">45</a>  
<a class="jxr_linenumber" name="46" href="#46">46</a>  	<em class="jxr_comment">// Zone Types</em>
<a class="jxr_linenumber" name="47" href="#47">47</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> ZONE_TYPE_INCLUSION = 0;
<a class="jxr_linenumber" name="48" href="#48">48</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> ZONE_TYPE_EXCLUSION = 1;
<a class="jxr_linenumber" name="49" href="#49">49</a>  
<a class="jxr_linenumber" name="50" href="#50">50</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> Uri CONTENT_URI = Uri
<a class="jxr_linenumber" name="51" href="#51">51</a>  		.parse(<span class="jxr_string">"content://org.inftel.tms.mobile.provider.fences/fences"</span>);
<a class="jxr_linenumber" name="52" href="#52">52</a>  
<a class="jxr_linenumber" name="53" href="#53">53</a>  	<em class="jxr_comment">// Create the constants used to differentiate between the different URI requests.</em>
<a class="jxr_linenumber" name="54" href="#54">54</a>  	<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> FENCES = 1;
<a class="jxr_linenumber" name="55" href="#55">55</a>  	<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> FENCES_ID = 2;
<a class="jxr_linenumber" name="56" href="#56">56</a>  
<a class="jxr_linenumber" name="57" href="#57">57</a>  	<em class="jxr_comment">// Allocate the UriMatcher object, where a URI ending in 'places' will</em>
<a class="jxr_linenumber" name="58" href="#58">58</a>  	<em class="jxr_comment">// correspond to a request for all places, and 'places' with a trailing '/[Unique ID]' will</em>
<a class="jxr_linenumber" name="59" href="#59">59</a>  	<em class="jxr_comment">// represent a single place details row.</em>
<a class="jxr_linenumber" name="60" href="#60">60</a>  	<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> UriMatcher uriMatcher;
<a class="jxr_linenumber" name="61" href="#61">61</a>  	<strong class="jxr_keyword">static</strong> {
<a class="jxr_linenumber" name="62" href="#62">62</a>  		uriMatcher = <strong class="jxr_keyword">new</strong> UriMatcher(UriMatcher.NO_MATCH);
<a class="jxr_linenumber" name="63" href="#63">63</a>  		uriMatcher.addURI(<span class="jxr_string">"org.inftel.tms.mobile.provider.fences"</span>, <span class="jxr_string">"fences"</span>, FENCES);
<a class="jxr_linenumber" name="64" href="#64">64</a>  		uriMatcher.addURI(<span class="jxr_string">"org.inftel.tms.mobile.provider.fences"</span>, <span class="jxr_string">"fences/*"</span>, FENCES_ID);
<a class="jxr_linenumber" name="65" href="#65">65</a>  	}
<a class="jxr_linenumber" name="66" href="#66">66</a>  
<a class="jxr_linenumber" name="67" href="#67">67</a>  	@Override
<a class="jxr_linenumber" name="68" href="#68">68</a>  	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">boolean</strong> onCreate() {
<a class="jxr_linenumber" name="69" href="#69">69</a>  		Context context = getContext();
<a class="jxr_linenumber" name="70" href="#70">70</a>  
<a class="jxr_linenumber" name="71" href="#71">71</a>  		PlacesDatabaseHelper dbHelper;
<a class="jxr_linenumber" name="72" href="#72">72</a>  		dbHelper = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/inftel/tms/mobile/contentproviders/FencesContentProvider.html">PlacesDatabaseHelper</a>(context, DATABASE_NAME, <strong class="jxr_keyword">null</strong>, DATABASE_VERSION);
<a class="jxr_linenumber" name="73" href="#73">73</a>  		<strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="74" href="#74">74</a>  			fencesDB = dbHelper.getWritableDatabase();
<a class="jxr_linenumber" name="75" href="#75">75</a>  		} <strong class="jxr_keyword">catch</strong> (SQLiteException e) {
<a class="jxr_linenumber" name="76" href="#76">76</a>  			fencesDB = <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="77" href="#77">77</a>  			Log.d(TAG, <span class="jxr_string">"Database Opening exception"</span>);
<a class="jxr_linenumber" name="78" href="#78">78</a>  		}
<a class="jxr_linenumber" name="79" href="#79">79</a>  
<a class="jxr_linenumber" name="80" href="#80">80</a>  		<strong class="jxr_keyword">return</strong> (fencesDB == <strong class="jxr_keyword">null</strong>) ? false : <strong class="jxr_keyword">true</strong>;
<a class="jxr_linenumber" name="81" href="#81">81</a>  	}
<a class="jxr_linenumber" name="82" href="#82">82</a>  
<a class="jxr_linenumber" name="83" href="#83">83</a>  	@Override
<a class="jxr_linenumber" name="84" href="#84">84</a>  	<strong class="jxr_keyword">public</strong> String getType(Uri uri) {
<a class="jxr_linenumber" name="85" href="#85">85</a>  		<strong class="jxr_keyword">switch</strong> (uriMatcher.match(uri)) {
<a class="jxr_linenumber" name="86" href="#86">86</a>  		<strong class="jxr_keyword">case</strong> FENCES:
<a class="jxr_linenumber" name="87" href="#87">87</a>  			<strong class="jxr_keyword">return</strong> <span class="jxr_string">"vnd.android.cursor.dir/vnd.inftel.tms.fence"</span>;
<a class="jxr_linenumber" name="88" href="#88">88</a>  		<strong class="jxr_keyword">case</strong> FENCES_ID:
<a class="jxr_linenumber" name="89" href="#89">89</a>  			<strong class="jxr_keyword">return</strong> <span class="jxr_string">"vnd.android.cursor.item/vnd.inftel.tms.fence"</span>;
<a class="jxr_linenumber" name="90" href="#90">90</a>  		<strong class="jxr_keyword">default</strong>:
<a class="jxr_linenumber" name="91" href="#91">91</a>  			<strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> IllegalArgumentException(<span class="jxr_string">"Unsupported URI: "</span> + uri);
<a class="jxr_linenumber" name="92" href="#92">92</a>  		}
<a class="jxr_linenumber" name="93" href="#93">93</a>  	}
<a class="jxr_linenumber" name="94" href="#94">94</a>  
<a class="jxr_linenumber" name="95" href="#95">95</a>  	@Override
<a class="jxr_linenumber" name="96" href="#96">96</a>  	<strong class="jxr_keyword">public</strong> Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs,
<a class="jxr_linenumber" name="97" href="#97">97</a>  		String sort) {
<a class="jxr_linenumber" name="98" href="#98">98</a>  		SQLiteQueryBuilder qb = <strong class="jxr_keyword">new</strong> SQLiteQueryBuilder();
<a class="jxr_linenumber" name="99" href="#99">99</a>  		qb.setTables(FENCES_TABLE);
<a class="jxr_linenumber" name="100" href="#100">100</a> 
<a class="jxr_linenumber" name="101" href="#101">101</a> 		<em class="jxr_comment">// If this is a row query, limit the result set to the passed in row.</em>
<a class="jxr_linenumber" name="102" href="#102">102</a> 		<strong class="jxr_keyword">switch</strong> (uriMatcher.match(uri)) {
<a class="jxr_linenumber" name="103" href="#103">103</a> 		<strong class="jxr_keyword">case</strong> FENCES_ID:
<a class="jxr_linenumber" name="104" href="#104">104</a> 			qb.appendWhere(KEY_ID + <span class="jxr_string">"="</span> + uri.getPathSegments().get(1));
<a class="jxr_linenumber" name="105" href="#105">105</a> 			<strong class="jxr_keyword">break</strong>;
<a class="jxr_linenumber" name="106" href="#106">106</a> 		<strong class="jxr_keyword">default</strong>:
<a class="jxr_linenumber" name="107" href="#107">107</a> 			<strong class="jxr_keyword">break</strong>;
<a class="jxr_linenumber" name="108" href="#108">108</a> 		}
<a class="jxr_linenumber" name="109" href="#109">109</a> 
<a class="jxr_linenumber" name="110" href="#110">110</a> 		String orderBy = <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="111" href="#111">111</a> 		<strong class="jxr_keyword">if</strong> (!TextUtils.isEmpty(sort)) {
<a class="jxr_linenumber" name="112" href="#112">112</a> 			orderBy = sort;
<a class="jxr_linenumber" name="113" href="#113">113</a> 		}
<a class="jxr_linenumber" name="114" href="#114">114</a> 
<a class="jxr_linenumber" name="115" href="#115">115</a> 		<em class="jxr_comment">// Apply the query to the underlying database.</em>
<a class="jxr_linenumber" name="116" href="#116">116</a> 		Cursor c = qb.query(fencesDB, projection, selection, selectionArgs, <strong class="jxr_keyword">null</strong>, <strong class="jxr_keyword">null</strong>, orderBy);
<a class="jxr_linenumber" name="117" href="#117">117</a> 
<a class="jxr_linenumber" name="118" href="#118">118</a> 		<em class="jxr_comment">// Register the contexts ContentResolver to be notified if</em>
<a class="jxr_linenumber" name="119" href="#119">119</a> 		<em class="jxr_comment">// the cursor result set changes.</em>
<a class="jxr_linenumber" name="120" href="#120">120</a> 		c.setNotificationUri(getContext().getContentResolver(), uri);
<a class="jxr_linenumber" name="121" href="#121">121</a> 
<a class="jxr_linenumber" name="122" href="#122">122</a> 		<em class="jxr_comment">// Return a cursor to the query result.</em>
<a class="jxr_linenumber" name="123" href="#123">123</a> 		<strong class="jxr_keyword">return</strong> c;
<a class="jxr_linenumber" name="124" href="#124">124</a> 	}
<a class="jxr_linenumber" name="125" href="#125">125</a> 
<a class="jxr_linenumber" name="126" href="#126">126</a> 	@Override
<a class="jxr_linenumber" name="127" href="#127">127</a> 	<strong class="jxr_keyword">public</strong> Uri insert(Uri _uri, ContentValues _initialValues) {
<a class="jxr_linenumber" name="128" href="#128">128</a> 		<em class="jxr_comment">// Insert the new row, will return the row number if successful.</em>
<a class="jxr_linenumber" name="129" href="#129">129</a> 		<strong class="jxr_keyword">long</strong> rowID = fencesDB.insert(FENCES_TABLE, <span class="jxr_string">"nullhack"</span>, _initialValues);
<a class="jxr_linenumber" name="130" href="#130">130</a> 
<a class="jxr_linenumber" name="131" href="#131">131</a> 		<em class="jxr_comment">// Return a URI to the newly inserted row on success.</em>
<a class="jxr_linenumber" name="132" href="#132">132</a> 		<strong class="jxr_keyword">if</strong> (rowID &gt; 0) {
<a class="jxr_linenumber" name="133" href="#133">133</a> 			Uri uri = ContentUris.withAppendedId(CONTENT_URI, rowID);
<a class="jxr_linenumber" name="134" href="#134">134</a> 			getContext().getContentResolver().notifyChange(uri, <strong class="jxr_keyword">null</strong>);
<a class="jxr_linenumber" name="135" href="#135">135</a> 			<strong class="jxr_keyword">return</strong> uri;
<a class="jxr_linenumber" name="136" href="#136">136</a> 		}
<a class="jxr_linenumber" name="137" href="#137">137</a> 		<strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> SQLException(<span class="jxr_string">"Failed to insert row into "</span> + _uri);
<a class="jxr_linenumber" name="138" href="#138">138</a> 	}
<a class="jxr_linenumber" name="139" href="#139">139</a> 
<a class="jxr_linenumber" name="140" href="#140">140</a> 	@Override
<a class="jxr_linenumber" name="141" href="#141">141</a> 	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> delete(Uri uri, String where, String[] whereArgs) {
<a class="jxr_linenumber" name="142" href="#142">142</a> 		<strong class="jxr_keyword">int</strong> count;
<a class="jxr_linenumber" name="143" href="#143">143</a> 
<a class="jxr_linenumber" name="144" href="#144">144</a> 		<strong class="jxr_keyword">switch</strong> (uriMatcher.match(uri)) {
<a class="jxr_linenumber" name="145" href="#145">145</a> 		<strong class="jxr_keyword">case</strong> FENCES:
<a class="jxr_linenumber" name="146" href="#146">146</a> 			count = fencesDB.delete(FENCES_TABLE, where, whereArgs);
<a class="jxr_linenumber" name="147" href="#147">147</a> 			<strong class="jxr_keyword">break</strong>;
<a class="jxr_linenumber" name="148" href="#148">148</a> 
<a class="jxr_linenumber" name="149" href="#149">149</a> 		<strong class="jxr_keyword">case</strong> FENCES_ID:
<a class="jxr_linenumber" name="150" href="#150">150</a> 			String segment = uri.getPathSegments().get(1);
<a class="jxr_linenumber" name="151" href="#151">151</a> 			count = fencesDB.delete(FENCES_TABLE, KEY_ID + <span class="jxr_string">"="</span>
<a class="jxr_linenumber" name="152" href="#152">152</a> 				+ segment
<a class="jxr_linenumber" name="153" href="#153">153</a> 				+ (!TextUtils.isEmpty(where) ? <span class="jxr_string">" AND ("</span>
<a class="jxr_linenumber" name="154" href="#154">154</a> 					+ where + ')' : <span class="jxr_string">""</span>), whereArgs);
<a class="jxr_linenumber" name="155" href="#155">155</a> 			<strong class="jxr_keyword">break</strong>;
<a class="jxr_linenumber" name="156" href="#156">156</a> 
<a class="jxr_linenumber" name="157" href="#157">157</a> 		<strong class="jxr_keyword">default</strong>:
<a class="jxr_linenumber" name="158" href="#158">158</a> 			<strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> IllegalArgumentException(<span class="jxr_string">"Unsupported URI: "</span> + uri);
<a class="jxr_linenumber" name="159" href="#159">159</a> 		}
<a class="jxr_linenumber" name="160" href="#160">160</a> 
<a class="jxr_linenumber" name="161" href="#161">161</a> 		getContext().getContentResolver().notifyChange(uri, <strong class="jxr_keyword">null</strong>);
<a class="jxr_linenumber" name="162" href="#162">162</a> 		<strong class="jxr_keyword">return</strong> count;
<a class="jxr_linenumber" name="163" href="#163">163</a> 	}
<a class="jxr_linenumber" name="164" href="#164">164</a> 
<a class="jxr_linenumber" name="165" href="#165">165</a> 	@Override
<a class="jxr_linenumber" name="166" href="#166">166</a> 	<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> update(Uri uri, ContentValues values, String where, String[] whereArgs) {
<a class="jxr_linenumber" name="167" href="#167">167</a> 		<strong class="jxr_keyword">int</strong> count;
<a class="jxr_linenumber" name="168" href="#168">168</a> 		<strong class="jxr_keyword">switch</strong> (uriMatcher.match(uri)) {
<a class="jxr_linenumber" name="169" href="#169">169</a> 		<strong class="jxr_keyword">case</strong> FENCES:
<a class="jxr_linenumber" name="170" href="#170">170</a> 			count = fencesDB.update(FENCES_TABLE, values, where, whereArgs);
<a class="jxr_linenumber" name="171" href="#171">171</a> 			<strong class="jxr_keyword">break</strong>;
<a class="jxr_linenumber" name="172" href="#172">172</a> 
<a class="jxr_linenumber" name="173" href="#173">173</a> 		<strong class="jxr_keyword">case</strong> FENCES_ID:
<a class="jxr_linenumber" name="174" href="#174">174</a> 			String segment = uri.getLastPathSegment();
<a class="jxr_linenumber" name="175" href="#175">175</a> 			count = fencesDB.update(FENCES_TABLE, values, KEY_ID + <span class="jxr_string">"="</span> + segment
<a class="jxr_linenumber" name="176" href="#176">176</a> 				+ (!isEmpty(where) ? <span class="jxr_string">" AND ("</span> + where + ')' : <span class="jxr_string">""</span>), whereArgs);
<a class="jxr_linenumber" name="177" href="#177">177</a> 			<strong class="jxr_keyword">break</strong>;
<a class="jxr_linenumber" name="178" href="#178">178</a> 
<a class="jxr_linenumber" name="179" href="#179">179</a> 		<strong class="jxr_keyword">default</strong>:
<a class="jxr_linenumber" name="180" href="#180">180</a> 			<strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> IllegalArgumentException(<span class="jxr_string">"Unknown URI "</span> + uri);
<a class="jxr_linenumber" name="181" href="#181">181</a> 		}
<a class="jxr_linenumber" name="182" href="#182">182</a> 
<a class="jxr_linenumber" name="183" href="#183">183</a> 		getContext().getContentResolver().notifyChange(uri, <strong class="jxr_keyword">null</strong>);
<a class="jxr_linenumber" name="184" href="#184">184</a> 		<strong class="jxr_keyword">return</strong> count;
<a class="jxr_linenumber" name="185" href="#185">185</a> 	}
<a class="jxr_linenumber" name="186" href="#186">186</a> 
<a class="jxr_linenumber" name="187" href="#187">187</a> 	<em class="jxr_comment">// Helper class for opening, creating, and managing database version control</em>
<a class="jxr_linenumber" name="188" href="#188">188</a> 	<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../org/inftel/tms/mobile/contentproviders/FencesContentProvider.html">PlacesDatabaseHelper</a> <strong class="jxr_keyword">extends</strong> SQLiteOpenHelper {
<a class="jxr_linenumber" name="189" href="#189">189</a> 		<strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String DATABASE_CREATE =
<a class="jxr_linenumber" name="190" href="#190">190</a> 			<span class="jxr_string">"create table "</span> + FENCES_TABLE + <span class="jxr_string">" ("</span>
<a class="jxr_linenumber" name="191" href="#191">191</a> 				+ KEY_ID + <span class="jxr_string">" INTEGER primary key autoincrement, "</span>
<a class="jxr_linenumber" name="192" href="#192">192</a> 				+ KEY_NAME + <span class="jxr_string">" TEXT, "</span>
<a class="jxr_linenumber" name="193" href="#193">193</a> 				+ KEY_LOCATION_LAT + <span class="jxr_string">" FLOAT, "</span>
<a class="jxr_linenumber" name="194" href="#194">194</a> 				+ KEY_LOCATION_LNG + <span class="jxr_string">" FLOAT, "</span>
<a class="jxr_linenumber" name="195" href="#195">195</a> 				+ KEY_ZONE_TYPE + <span class="jxr_string">" LONG, "</span>
<a class="jxr_linenumber" name="196" href="#196">196</a> 				+ KEY_RADIUS + <span class="jxr_string">" LONG, "</span>
<a class="jxr_linenumber" name="197" href="#197">197</a> 				+ KEY_LAST_UPDATE_TIME + <span class="jxr_string">" LONG); "</span>;
<a class="jxr_linenumber" name="198" href="#198">198</a> 
<a class="jxr_linenumber" name="199" href="#199">199</a> 		<strong class="jxr_keyword">public</strong> <a href="../../../../../org/inftel/tms/mobile/contentproviders/FencesContentProvider.html">PlacesDatabaseHelper</a>(Context context, String name, CursorFactory factory, <strong class="jxr_keyword">int</strong> version) {
<a class="jxr_linenumber" name="200" href="#200">200</a> 			<strong class="jxr_keyword">super</strong>(context, name, factory, version);
<a class="jxr_linenumber" name="201" href="#201">201</a> 		}
<a class="jxr_linenumber" name="202" href="#202">202</a> 
<a class="jxr_linenumber" name="203" href="#203">203</a> 		@Override
<a class="jxr_linenumber" name="204" href="#204">204</a> 		<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onCreate(SQLiteDatabase db) {
<a class="jxr_linenumber" name="205" href="#205">205</a> 			db.execSQL(DATABASE_CREATE);
<a class="jxr_linenumber" name="206" href="#206">206</a> 		}
<a class="jxr_linenumber" name="207" href="#207">207</a> 
<a class="jxr_linenumber" name="208" href="#208">208</a> 		@Override
<a class="jxr_linenumber" name="209" href="#209">209</a> 		<strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onUpgrade(SQLiteDatabase db, <strong class="jxr_keyword">int</strong> oldVersion, <strong class="jxr_keyword">int</strong> newVersion) {
<a class="jxr_linenumber" name="210" href="#210">210</a> 			Log.w(TAG, <span class="jxr_string">"Upgrading database from version "</span> + oldVersion + <span class="jxr_string">" to "</span>
<a class="jxr_linenumber" name="211" href="#211">211</a> 				+ newVersion + <span class="jxr_string">", which will destroy all old data"</span>);
<a class="jxr_linenumber" name="212" href="#212">212</a> 
<a class="jxr_linenumber" name="213" href="#213">213</a> 			db.execSQL(<span class="jxr_string">"DROP TABLE IF EXISTS "</span> + FENCES_TABLE);
<a class="jxr_linenumber" name="214" href="#214">214</a> 			onCreate(db);
<a class="jxr_linenumber" name="215" href="#215">215</a> 		}
<a class="jxr_linenumber" name="216" href="#216">216</a> 	}
<a class="jxr_linenumber" name="217" href="#217">217</a> }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

